package com.cg.domain;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class PitayaStockExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public PitayaStockExample() {
        oredCriteria = new ArrayList<>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andStockIdIsNull() {
            addCriterion("stock_id is null");
            return (Criteria) this;
        }

        public Criteria andStockIdIsNotNull() {
            addCriterion("stock_id is not null");
            return (Criteria) this;
        }

        public Criteria andStockIdEqualTo(Integer value) {
            addCriterion("stock_id =", value, "stockId");
            return (Criteria) this;
        }

        public Criteria andStockIdNotEqualTo(Integer value) {
            addCriterion("stock_id <>", value, "stockId");
            return (Criteria) this;
        }

        public Criteria andStockIdGreaterThan(Integer value) {
            addCriterion("stock_id >", value, "stockId");
            return (Criteria) this;
        }

        public Criteria andStockIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("stock_id >=", value, "stockId");
            return (Criteria) this;
        }

        public Criteria andStockIdLessThan(Integer value) {
            addCriterion("stock_id <", value, "stockId");
            return (Criteria) this;
        }

        public Criteria andStockIdLessThanOrEqualTo(Integer value) {
            addCriterion("stock_id <=", value, "stockId");
            return (Criteria) this;
        }

        public Criteria andStockIdIn(List<Integer> values) {
            addCriterion("stock_id in", values, "stockId");
            return (Criteria) this;
        }

        public Criteria andStockIdNotIn(List<Integer> values) {
            addCriterion("stock_id not in", values, "stockId");
            return (Criteria) this;
        }

        public Criteria andStockIdBetween(Integer value1, Integer value2) {
            addCriterion("stock_id between", value1, value2, "stockId");
            return (Criteria) this;
        }

        public Criteria andStockIdNotBetween(Integer value1, Integer value2) {
            addCriterion("stock_id not between", value1, value2, "stockId");
            return (Criteria) this;
        }

        public Criteria andCommodityIdIsNull() {
            addCriterion("commodity_id is null");
            return (Criteria) this;
        }

        public Criteria andCommodityIdIsNotNull() {
            addCriterion("commodity_id is not null");
            return (Criteria) this;
        }

        public Criteria andCommodityIdEqualTo(Integer value) {
            addCriterion("commodity_id =", value, "commodityId");
            return (Criteria) this;
        }

        public Criteria andCommodityIdNotEqualTo(Integer value) {
            addCriterion("commodity_id <>", value, "commodityId");
            return (Criteria) this;
        }

        public Criteria andCommodityIdGreaterThan(Integer value) {
            addCriterion("commodity_id >", value, "commodityId");
            return (Criteria) this;
        }

        public Criteria andCommodityIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("commodity_id >=", value, "commodityId");
            return (Criteria) this;
        }

        public Criteria andCommodityIdLessThan(Integer value) {
            addCriterion("commodity_id <", value, "commodityId");
            return (Criteria) this;
        }

        public Criteria andCommodityIdLessThanOrEqualTo(Integer value) {
            addCriterion("commodity_id <=", value, "commodityId");
            return (Criteria) this;
        }

        public Criteria andCommodityIdIn(List<Integer> values) {
            addCriterion("commodity_id in", values, "commodityId");
            return (Criteria) this;
        }

        public Criteria andCommodityIdNotIn(List<Integer> values) {
            addCriterion("commodity_id not in", values, "commodityId");
            return (Criteria) this;
        }

        public Criteria andCommodityIdBetween(Integer value1, Integer value2) {
            addCriterion("commodity_id between", value1, value2, "commodityId");
            return (Criteria) this;
        }

        public Criteria andCommodityIdNotBetween(Integer value1, Integer value2) {
            addCriterion("commodity_id not between", value1, value2, "commodityId");
            return (Criteria) this;
        }

        public Criteria andCommodityNameIsNull() {
            addCriterion("commodity_name is null");
            return (Criteria) this;
        }

        public Criteria andCommodityNameIsNotNull() {
            addCriterion("commodity_name is not null");
            return (Criteria) this;
        }

        public Criteria andCommodityNameEqualTo(String value) {
            addCriterion("commodity_name =", value, "commodityName");
            return (Criteria) this;
        }

        public Criteria andCommodityNameNotEqualTo(String value) {
            addCriterion("commodity_name <>", value, "commodityName");
            return (Criteria) this;
        }

        public Criteria andCommodityNameGreaterThan(String value) {
            addCriterion("commodity_name >", value, "commodityName");
            return (Criteria) this;
        }

        public Criteria andCommodityNameGreaterThanOrEqualTo(String value) {
            addCriterion("commodity_name >=", value, "commodityName");
            return (Criteria) this;
        }

        public Criteria andCommodityNameLessThan(String value) {
            addCriterion("commodity_name <", value, "commodityName");
            return (Criteria) this;
        }

        public Criteria andCommodityNameLessThanOrEqualTo(String value) {
            addCriterion("commodity_name <=", value, "commodityName");
            return (Criteria) this;
        }

        public Criteria andCommodityNameLike(String value) {
            addCriterion("commodity_name like", value, "commodityName");
            return (Criteria) this;
        }

        public Criteria andCommodityNameNotLike(String value) {
            addCriterion("commodity_name not like", value, "commodityName");
            return (Criteria) this;
        }

        public Criteria andCommodityNameIn(List<String> values) {
            addCriterion("commodity_name in", values, "commodityName");
            return (Criteria) this;
        }

        public Criteria andCommodityNameNotIn(List<String> values) {
            addCriterion("commodity_name not in", values, "commodityName");
            return (Criteria) this;
        }

        public Criteria andCommodityNameBetween(String value1, String value2) {
            addCriterion("commodity_name between", value1, value2, "commodityName");
            return (Criteria) this;
        }

        public Criteria andCommodityNameNotBetween(String value1, String value2) {
            addCriterion("commodity_name not between", value1, value2, "commodityName");
            return (Criteria) this;
        }

        public Criteria andStorehouseIdIsNull() {
            addCriterion("storehouse_id is null");
            return (Criteria) this;
        }

        public Criteria andStorehouseIdIsNotNull() {
            addCriterion("storehouse_id is not null");
            return (Criteria) this;
        }

        public Criteria andStorehouseIdEqualTo(Integer value) {
            addCriterion("storehouse_id =", value, "storehouseId");
            return (Criteria) this;
        }

        public Criteria andStorehouseIdNotEqualTo(Integer value) {
            addCriterion("storehouse_id <>", value, "storehouseId");
            return (Criteria) this;
        }

        public Criteria andStorehouseIdGreaterThan(Integer value) {
            addCriterion("storehouse_id >", value, "storehouseId");
            return (Criteria) this;
        }

        public Criteria andStorehouseIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("storehouse_id >=", value, "storehouseId");
            return (Criteria) this;
        }

        public Criteria andStorehouseIdLessThan(Integer value) {
            addCriterion("storehouse_id <", value, "storehouseId");
            return (Criteria) this;
        }

        public Criteria andStorehouseIdLessThanOrEqualTo(Integer value) {
            addCriterion("storehouse_id <=", value, "storehouseId");
            return (Criteria) this;
        }

        public Criteria andStorehouseIdIn(List<Integer> values) {
            addCriterion("storehouse_id in", values, "storehouseId");
            return (Criteria) this;
        }

        public Criteria andStorehouseIdNotIn(List<Integer> values) {
            addCriterion("storehouse_id not in", values, "storehouseId");
            return (Criteria) this;
        }

        public Criteria andStorehouseIdBetween(Integer value1, Integer value2) {
            addCriterion("storehouse_id between", value1, value2, "storehouseId");
            return (Criteria) this;
        }

        public Criteria andStorehouseIdNotBetween(Integer value1, Integer value2) {
            addCriterion("storehouse_id not between", value1, value2, "storehouseId");
            return (Criteria) this;
        }

        public Criteria andStorehouseNameIsNull() {
            addCriterion("storehouse_name is null");
            return (Criteria) this;
        }

        public Criteria andStorehouseNameIsNotNull() {
            addCriterion("storehouse_name is not null");
            return (Criteria) this;
        }

        public Criteria andStorehouseNameEqualTo(String value) {
            addCriterion("storehouse_name =", value, "storehouseName");
            return (Criteria) this;
        }

        public Criteria andStorehouseNameNotEqualTo(String value) {
            addCriterion("storehouse_name <>", value, "storehouseName");
            return (Criteria) this;
        }

        public Criteria andStorehouseNameGreaterThan(String value) {
            addCriterion("storehouse_name >", value, "storehouseName");
            return (Criteria) this;
        }

        public Criteria andStorehouseNameGreaterThanOrEqualTo(String value) {
            addCriterion("storehouse_name >=", value, "storehouseName");
            return (Criteria) this;
        }

        public Criteria andStorehouseNameLessThan(String value) {
            addCriterion("storehouse_name <", value, "storehouseName");
            return (Criteria) this;
        }

        public Criteria andStorehouseNameLessThanOrEqualTo(String value) {
            addCriterion("storehouse_name <=", value, "storehouseName");
            return (Criteria) this;
        }

        public Criteria andStorehouseNameLike(String value) {
            addCriterion("storehouse_name like", value, "storehouseName");
            return (Criteria) this;
        }

        public Criteria andStorehouseNameNotLike(String value) {
            addCriterion("storehouse_name not like", value, "storehouseName");
            return (Criteria) this;
        }

        public Criteria andStorehouseNameIn(List<String> values) {
            addCriterion("storehouse_name in", values, "storehouseName");
            return (Criteria) this;
        }

        public Criteria andStorehouseNameNotIn(List<String> values) {
            addCriterion("storehouse_name not in", values, "storehouseName");
            return (Criteria) this;
        }

        public Criteria andStorehouseNameBetween(String value1, String value2) {
            addCriterion("storehouse_name between", value1, value2, "storehouseName");
            return (Criteria) this;
        }

        public Criteria andStorehouseNameNotBetween(String value1, String value2) {
            addCriterion("storehouse_name not between", value1, value2, "storehouseName");
            return (Criteria) this;
        }

        public Criteria andCommodityTypeIdIsNull() {
            addCriterion("commodity_type_id is null");
            return (Criteria) this;
        }

        public Criteria andCommodityTypeIdIsNotNull() {
            addCriterion("commodity_type_id is not null");
            return (Criteria) this;
        }

        public Criteria andCommodityTypeIdEqualTo(Integer value) {
            addCriterion("commodity_type_id =", value, "commodityTypeId");
            return (Criteria) this;
        }

        public Criteria andCommodityTypeIdNotEqualTo(Integer value) {
            addCriterion("commodity_type_id <>", value, "commodityTypeId");
            return (Criteria) this;
        }

        public Criteria andCommodityTypeIdGreaterThan(Integer value) {
            addCriterion("commodity_type_id >", value, "commodityTypeId");
            return (Criteria) this;
        }

        public Criteria andCommodityTypeIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("commodity_type_id >=", value, "commodityTypeId");
            return (Criteria) this;
        }

        public Criteria andCommodityTypeIdLessThan(Integer value) {
            addCriterion("commodity_type_id <", value, "commodityTypeId");
            return (Criteria) this;
        }

        public Criteria andCommodityTypeIdLessThanOrEqualTo(Integer value) {
            addCriterion("commodity_type_id <=", value, "commodityTypeId");
            return (Criteria) this;
        }

        public Criteria andCommodityTypeIdIn(List<Integer> values) {
            addCriterion("commodity_type_id in", values, "commodityTypeId");
            return (Criteria) this;
        }

        public Criteria andCommodityTypeIdNotIn(List<Integer> values) {
            addCriterion("commodity_type_id not in", values, "commodityTypeId");
            return (Criteria) this;
        }

        public Criteria andCommodityTypeIdBetween(Integer value1, Integer value2) {
            addCriterion("commodity_type_id between", value1, value2, "commodityTypeId");
            return (Criteria) this;
        }

        public Criteria andCommodityTypeIdNotBetween(Integer value1, Integer value2) {
            addCriterion("commodity_type_id not between", value1, value2, "commodityTypeId");
            return (Criteria) this;
        }

        public Criteria andParentCommodityTypeNameIsNull() {
            addCriterion("parent_commodity_type_name is null");
            return (Criteria) this;
        }

        public Criteria andParentCommodityTypeNameIsNotNull() {
            addCriterion("parent_commodity_type_name is not null");
            return (Criteria) this;
        }

        public Criteria andParentCommodityTypeNameEqualTo(String value) {
            addCriterion("parent_commodity_type_name =", value, "parentCommodityTypeName");
            return (Criteria) this;
        }

        public Criteria andParentCommodityTypeNameNotEqualTo(String value) {
            addCriterion("parent_commodity_type_name <>", value, "parentCommodityTypeName");
            return (Criteria) this;
        }

        public Criteria andParentCommodityTypeNameGreaterThan(String value) {
            addCriterion("parent_commodity_type_name >", value, "parentCommodityTypeName");
            return (Criteria) this;
        }

        public Criteria andParentCommodityTypeNameGreaterThanOrEqualTo(String value) {
            addCriterion("parent_commodity_type_name >=", value, "parentCommodityTypeName");
            return (Criteria) this;
        }

        public Criteria andParentCommodityTypeNameLessThan(String value) {
            addCriterion("parent_commodity_type_name <", value, "parentCommodityTypeName");
            return (Criteria) this;
        }

        public Criteria andParentCommodityTypeNameLessThanOrEqualTo(String value) {
            addCriterion("parent_commodity_type_name <=", value, "parentCommodityTypeName");
            return (Criteria) this;
        }

        public Criteria andParentCommodityTypeNameLike(String value) {
            addCriterion("parent_commodity_type_name like", value, "parentCommodityTypeName");
            return (Criteria) this;
        }

        public Criteria andParentCommodityTypeNameNotLike(String value) {
            addCriterion("parent_commodity_type_name not like", value, "parentCommodityTypeName");
            return (Criteria) this;
        }

        public Criteria andParentCommodityTypeNameIn(List<String> values) {
            addCriterion("parent_commodity_type_name in", values, "parentCommodityTypeName");
            return (Criteria) this;
        }

        public Criteria andParentCommodityTypeNameNotIn(List<String> values) {
            addCriterion("parent_commodity_type_name not in", values, "parentCommodityTypeName");
            return (Criteria) this;
        }

        public Criteria andParentCommodityTypeNameBetween(String value1, String value2) {
            addCriterion("parent_commodity_type_name between", value1, value2, "parentCommodityTypeName");
            return (Criteria) this;
        }

        public Criteria andParentCommodityTypeNameNotBetween(String value1, String value2) {
            addCriterion("parent_commodity_type_name not between", value1, value2, "parentCommodityTypeName");
            return (Criteria) this;
        }

        public Criteria andCustomerGroupIdIsNull() {
            addCriterion("customer_group_id is null");
            return (Criteria) this;
        }

        public Criteria andCustomerGroupIdIsNotNull() {
            addCriterion("customer_group_id is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerGroupIdEqualTo(Integer value) {
            addCriterion("customer_group_id =", value, "customerGroupId");
            return (Criteria) this;
        }

        public Criteria andCustomerGroupIdNotEqualTo(Integer value) {
            addCriterion("customer_group_id <>", value, "customerGroupId");
            return (Criteria) this;
        }

        public Criteria andCustomerGroupIdGreaterThan(Integer value) {
            addCriterion("customer_group_id >", value, "customerGroupId");
            return (Criteria) this;
        }

        public Criteria andCustomerGroupIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("customer_group_id >=", value, "customerGroupId");
            return (Criteria) this;
        }

        public Criteria andCustomerGroupIdLessThan(Integer value) {
            addCriterion("customer_group_id <", value, "customerGroupId");
            return (Criteria) this;
        }

        public Criteria andCustomerGroupIdLessThanOrEqualTo(Integer value) {
            addCriterion("customer_group_id <=", value, "customerGroupId");
            return (Criteria) this;
        }

        public Criteria andCustomerGroupIdIn(List<Integer> values) {
            addCriterion("customer_group_id in", values, "customerGroupId");
            return (Criteria) this;
        }

        public Criteria andCustomerGroupIdNotIn(List<Integer> values) {
            addCriterion("customer_group_id not in", values, "customerGroupId");
            return (Criteria) this;
        }

        public Criteria andCustomerGroupIdBetween(Integer value1, Integer value2) {
            addCriterion("customer_group_id between", value1, value2, "customerGroupId");
            return (Criteria) this;
        }

        public Criteria andCustomerGroupIdNotBetween(Integer value1, Integer value2) {
            addCriterion("customer_group_id not between", value1, value2, "customerGroupId");
            return (Criteria) this;
        }

        public Criteria andCustomerGroupNameIsNull() {
            addCriterion("customer_group_name is null");
            return (Criteria) this;
        }

        public Criteria andCustomerGroupNameIsNotNull() {
            addCriterion("customer_group_name is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerGroupNameEqualTo(String value) {
            addCriterion("customer_group_name =", value, "customerGroupName");
            return (Criteria) this;
        }

        public Criteria andCustomerGroupNameNotEqualTo(String value) {
            addCriterion("customer_group_name <>", value, "customerGroupName");
            return (Criteria) this;
        }

        public Criteria andCustomerGroupNameGreaterThan(String value) {
            addCriterion("customer_group_name >", value, "customerGroupName");
            return (Criteria) this;
        }

        public Criteria andCustomerGroupNameGreaterThanOrEqualTo(String value) {
            addCriterion("customer_group_name >=", value, "customerGroupName");
            return (Criteria) this;
        }

        public Criteria andCustomerGroupNameLessThan(String value) {
            addCriterion("customer_group_name <", value, "customerGroupName");
            return (Criteria) this;
        }

        public Criteria andCustomerGroupNameLessThanOrEqualTo(String value) {
            addCriterion("customer_group_name <=", value, "customerGroupName");
            return (Criteria) this;
        }

        public Criteria andCustomerGroupNameLike(String value) {
            addCriterion("customer_group_name like", value, "customerGroupName");
            return (Criteria) this;
        }

        public Criteria andCustomerGroupNameNotLike(String value) {
            addCriterion("customer_group_name not like", value, "customerGroupName");
            return (Criteria) this;
        }

        public Criteria andCustomerGroupNameIn(List<String> values) {
            addCriterion("customer_group_name in", values, "customerGroupName");
            return (Criteria) this;
        }

        public Criteria andCustomerGroupNameNotIn(List<String> values) {
            addCriterion("customer_group_name not in", values, "customerGroupName");
            return (Criteria) this;
        }

        public Criteria andCustomerGroupNameBetween(String value1, String value2) {
            addCriterion("customer_group_name between", value1, value2, "customerGroupName");
            return (Criteria) this;
        }

        public Criteria andCustomerGroupNameNotBetween(String value1, String value2) {
            addCriterion("customer_group_name not between", value1, value2, "customerGroupName");
            return (Criteria) this;
        }

        public Criteria andOrganizationIdIsNull() {
            addCriterion("organization_id is null");
            return (Criteria) this;
        }

        public Criteria andOrganizationIdIsNotNull() {
            addCriterion("organization_id is not null");
            return (Criteria) this;
        }

        public Criteria andOrganizationIdEqualTo(Integer value) {
            addCriterion("organization_id =", value, "organizationId");
            return (Criteria) this;
        }

        public Criteria andOrganizationIdNotEqualTo(Integer value) {
            addCriterion("organization_id <>", value, "organizationId");
            return (Criteria) this;
        }

        public Criteria andOrganizationIdGreaterThan(Integer value) {
            addCriterion("organization_id >", value, "organizationId");
            return (Criteria) this;
        }

        public Criteria andOrganizationIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("organization_id >=", value, "organizationId");
            return (Criteria) this;
        }

        public Criteria andOrganizationIdLessThan(Integer value) {
            addCriterion("organization_id <", value, "organizationId");
            return (Criteria) this;
        }

        public Criteria andOrganizationIdLessThanOrEqualTo(Integer value) {
            addCriterion("organization_id <=", value, "organizationId");
            return (Criteria) this;
        }

        public Criteria andOrganizationIdIn(List<Integer> values) {
            addCriterion("organization_id in", values, "organizationId");
            return (Criteria) this;
        }

        public Criteria andOrganizationIdNotIn(List<Integer> values) {
            addCriterion("organization_id not in", values, "organizationId");
            return (Criteria) this;
        }

        public Criteria andOrganizationIdBetween(Integer value1, Integer value2) {
            addCriterion("organization_id between", value1, value2, "organizationId");
            return (Criteria) this;
        }

        public Criteria andOrganizationIdNotBetween(Integer value1, Integer value2) {
            addCriterion("organization_id not between", value1, value2, "organizationId");
            return (Criteria) this;
        }

        public Criteria andOrganizationNameIsNull() {
            addCriterion("organization_name is null");
            return (Criteria) this;
        }

        public Criteria andOrganizationNameIsNotNull() {
            addCriterion("organization_name is not null");
            return (Criteria) this;
        }

        public Criteria andOrganizationNameEqualTo(String value) {
            addCriterion("organization_name =", value, "organizationName");
            return (Criteria) this;
        }

        public Criteria andOrganizationNameNotEqualTo(String value) {
            addCriterion("organization_name <>", value, "organizationName");
            return (Criteria) this;
        }

        public Criteria andOrganizationNameGreaterThan(String value) {
            addCriterion("organization_name >", value, "organizationName");
            return (Criteria) this;
        }

        public Criteria andOrganizationNameGreaterThanOrEqualTo(String value) {
            addCriterion("organization_name >=", value, "organizationName");
            return (Criteria) this;
        }

        public Criteria andOrganizationNameLessThan(String value) {
            addCriterion("organization_name <", value, "organizationName");
            return (Criteria) this;
        }

        public Criteria andOrganizationNameLessThanOrEqualTo(String value) {
            addCriterion("organization_name <=", value, "organizationName");
            return (Criteria) this;
        }

        public Criteria andOrganizationNameLike(String value) {
            addCriterion("organization_name like", value, "organizationName");
            return (Criteria) this;
        }

        public Criteria andOrganizationNameNotLike(String value) {
            addCriterion("organization_name not like", value, "organizationName");
            return (Criteria) this;
        }

        public Criteria andOrganizationNameIn(List<String> values) {
            addCriterion("organization_name in", values, "organizationName");
            return (Criteria) this;
        }

        public Criteria andOrganizationNameNotIn(List<String> values) {
            addCriterion("organization_name not in", values, "organizationName");
            return (Criteria) this;
        }

        public Criteria andOrganizationNameBetween(String value1, String value2) {
            addCriterion("organization_name between", value1, value2, "organizationName");
            return (Criteria) this;
        }

        public Criteria andOrganizationNameNotBetween(String value1, String value2) {
            addCriterion("organization_name not between", value1, value2, "organizationName");
            return (Criteria) this;
        }

        public Criteria andCommoditySpecsIdIsNull() {
            addCriterion("commodity_specs_id is null");
            return (Criteria) this;
        }

        public Criteria andCommoditySpecsIdIsNotNull() {
            addCriterion("commodity_specs_id is not null");
            return (Criteria) this;
        }

        public Criteria andCommoditySpecsIdEqualTo(Integer value) {
            addCriterion("commodity_specs_id =", value, "commoditySpecsId");
            return (Criteria) this;
        }

        public Criteria andCommoditySpecsIdNotEqualTo(Integer value) {
            addCriterion("commodity_specs_id <>", value, "commoditySpecsId");
            return (Criteria) this;
        }

        public Criteria andCommoditySpecsIdGreaterThan(Integer value) {
            addCriterion("commodity_specs_id >", value, "commoditySpecsId");
            return (Criteria) this;
        }

        public Criteria andCommoditySpecsIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("commodity_specs_id >=", value, "commoditySpecsId");
            return (Criteria) this;
        }

        public Criteria andCommoditySpecsIdLessThan(Integer value) {
            addCriterion("commodity_specs_id <", value, "commoditySpecsId");
            return (Criteria) this;
        }

        public Criteria andCommoditySpecsIdLessThanOrEqualTo(Integer value) {
            addCriterion("commodity_specs_id <=", value, "commoditySpecsId");
            return (Criteria) this;
        }

        public Criteria andCommoditySpecsIdIn(List<Integer> values) {
            addCriterion("commodity_specs_id in", values, "commoditySpecsId");
            return (Criteria) this;
        }

        public Criteria andCommoditySpecsIdNotIn(List<Integer> values) {
            addCriterion("commodity_specs_id not in", values, "commoditySpecsId");
            return (Criteria) this;
        }

        public Criteria andCommoditySpecsIdBetween(Integer value1, Integer value2) {
            addCriterion("commodity_specs_id between", value1, value2, "commoditySpecsId");
            return (Criteria) this;
        }

        public Criteria andCommoditySpecsIdNotBetween(Integer value1, Integer value2) {
            addCriterion("commodity_specs_id not between", value1, value2, "commoditySpecsId");
            return (Criteria) this;
        }

        public Criteria andCommoditySpecsNameIsNull() {
            addCriterion("commodity_specs_name is null");
            return (Criteria) this;
        }

        public Criteria andCommoditySpecsNameIsNotNull() {
            addCriterion("commodity_specs_name is not null");
            return (Criteria) this;
        }

        public Criteria andCommoditySpecsNameEqualTo(String value) {
            addCriterion("commodity_specs_name =", value, "commoditySpecsName");
            return (Criteria) this;
        }

        public Criteria andCommoditySpecsNameNotEqualTo(String value) {
            addCriterion("commodity_specs_name <>", value, "commoditySpecsName");
            return (Criteria) this;
        }

        public Criteria andCommoditySpecsNameGreaterThan(String value) {
            addCriterion("commodity_specs_name >", value, "commoditySpecsName");
            return (Criteria) this;
        }

        public Criteria andCommoditySpecsNameGreaterThanOrEqualTo(String value) {
            addCriterion("commodity_specs_name >=", value, "commoditySpecsName");
            return (Criteria) this;
        }

        public Criteria andCommoditySpecsNameLessThan(String value) {
            addCriterion("commodity_specs_name <", value, "commoditySpecsName");
            return (Criteria) this;
        }

        public Criteria andCommoditySpecsNameLessThanOrEqualTo(String value) {
            addCriterion("commodity_specs_name <=", value, "commoditySpecsName");
            return (Criteria) this;
        }

        public Criteria andCommoditySpecsNameLike(String value) {
            addCriterion("commodity_specs_name like", value, "commoditySpecsName");
            return (Criteria) this;
        }

        public Criteria andCommoditySpecsNameNotLike(String value) {
            addCriterion("commodity_specs_name not like", value, "commoditySpecsName");
            return (Criteria) this;
        }

        public Criteria andCommoditySpecsNameIn(List<String> values) {
            addCriterion("commodity_specs_name in", values, "commoditySpecsName");
            return (Criteria) this;
        }

        public Criteria andCommoditySpecsNameNotIn(List<String> values) {
            addCriterion("commodity_specs_name not in", values, "commoditySpecsName");
            return (Criteria) this;
        }

        public Criteria andCommoditySpecsNameBetween(String value1, String value2) {
            addCriterion("commodity_specs_name between", value1, value2, "commoditySpecsName");
            return (Criteria) this;
        }

        public Criteria andCommoditySpecsNameNotBetween(String value1, String value2) {
            addCriterion("commodity_specs_name not between", value1, value2, "commoditySpecsName");
            return (Criteria) this;
        }

        public Criteria andParentNumIsNull() {
            addCriterion("parent_num is null");
            return (Criteria) this;
        }

        public Criteria andParentNumIsNotNull() {
            addCriterion("parent_num is not null");
            return (Criteria) this;
        }

        public Criteria andParentNumEqualTo(Integer value) {
            addCriterion("parent_num =", value, "parentNum");
            return (Criteria) this;
        }

        public Criteria andParentNumNotEqualTo(Integer value) {
            addCriterion("parent_num <>", value, "parentNum");
            return (Criteria) this;
        }

        public Criteria andParentNumGreaterThan(Integer value) {
            addCriterion("parent_num >", value, "parentNum");
            return (Criteria) this;
        }

        public Criteria andParentNumGreaterThanOrEqualTo(Integer value) {
            addCriterion("parent_num >=", value, "parentNum");
            return (Criteria) this;
        }

        public Criteria andParentNumLessThan(Integer value) {
            addCriterion("parent_num <", value, "parentNum");
            return (Criteria) this;
        }

        public Criteria andParentNumLessThanOrEqualTo(Integer value) {
            addCriterion("parent_num <=", value, "parentNum");
            return (Criteria) this;
        }

        public Criteria andParentNumIn(List<Integer> values) {
            addCriterion("parent_num in", values, "parentNum");
            return (Criteria) this;
        }

        public Criteria andParentNumNotIn(List<Integer> values) {
            addCriterion("parent_num not in", values, "parentNum");
            return (Criteria) this;
        }

        public Criteria andParentNumBetween(Integer value1, Integer value2) {
            addCriterion("parent_num between", value1, value2, "parentNum");
            return (Criteria) this;
        }

        public Criteria andParentNumNotBetween(Integer value1, Integer value2) {
            addCriterion("parent_num not between", value1, value2, "parentNum");
            return (Criteria) this;
        }

        public Criteria andParentNumTypeIsNull() {
            addCriterion("parent_num_type is null");
            return (Criteria) this;
        }

        public Criteria andParentNumTypeIsNotNull() {
            addCriterion("parent_num_type is not null");
            return (Criteria) this;
        }

        public Criteria andParentNumTypeEqualTo(Short value) {
            addCriterion("parent_num_type =", value, "parentNumType");
            return (Criteria) this;
        }

        public Criteria andParentNumTypeNotEqualTo(Short value) {
            addCriterion("parent_num_type <>", value, "parentNumType");
            return (Criteria) this;
        }

        public Criteria andParentNumTypeGreaterThan(Short value) {
            addCriterion("parent_num_type >", value, "parentNumType");
            return (Criteria) this;
        }

        public Criteria andParentNumTypeGreaterThanOrEqualTo(Short value) {
            addCriterion("parent_num_type >=", value, "parentNumType");
            return (Criteria) this;
        }

        public Criteria andParentNumTypeLessThan(Short value) {
            addCriterion("parent_num_type <", value, "parentNumType");
            return (Criteria) this;
        }

        public Criteria andParentNumTypeLessThanOrEqualTo(Short value) {
            addCriterion("parent_num_type <=", value, "parentNumType");
            return (Criteria) this;
        }

        public Criteria andParentNumTypeIn(List<Short> values) {
            addCriterion("parent_num_type in", values, "parentNumType");
            return (Criteria) this;
        }

        public Criteria andParentNumTypeNotIn(List<Short> values) {
            addCriterion("parent_num_type not in", values, "parentNumType");
            return (Criteria) this;
        }

        public Criteria andParentNumTypeBetween(Short value1, Short value2) {
            addCriterion("parent_num_type between", value1, value2, "parentNumType");
            return (Criteria) this;
        }

        public Criteria andParentNumTypeNotBetween(Short value1, Short value2) {
            addCriterion("parent_num_type not between", value1, value2, "parentNumType");
            return (Criteria) this;
        }

        public Criteria andMinNumIsNull() {
            addCriterion("min_num is null");
            return (Criteria) this;
        }

        public Criteria andMinNumIsNotNull() {
            addCriterion("min_num is not null");
            return (Criteria) this;
        }

        public Criteria andMinNumEqualTo(BigDecimal value) {
            addCriterion("min_num =", value, "minNum");
            return (Criteria) this;
        }

        public Criteria andMinNumNotEqualTo(BigDecimal value) {
            addCriterion("min_num <>", value, "minNum");
            return (Criteria) this;
        }

        public Criteria andMinNumGreaterThan(BigDecimal value) {
            addCriterion("min_num >", value, "minNum");
            return (Criteria) this;
        }

        public Criteria andMinNumGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("min_num >=", value, "minNum");
            return (Criteria) this;
        }

        public Criteria andMinNumLessThan(BigDecimal value) {
            addCriterion("min_num <", value, "minNum");
            return (Criteria) this;
        }

        public Criteria andMinNumLessThanOrEqualTo(BigDecimal value) {
            addCriterion("min_num <=", value, "minNum");
            return (Criteria) this;
        }

        public Criteria andMinNumIn(List<BigDecimal> values) {
            addCriterion("min_num in", values, "minNum");
            return (Criteria) this;
        }

        public Criteria andMinNumNotIn(List<BigDecimal> values) {
            addCriterion("min_num not in", values, "minNum");
            return (Criteria) this;
        }

        public Criteria andMinNumBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("min_num between", value1, value2, "minNum");
            return (Criteria) this;
        }

        public Criteria andMinNumNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("min_num not between", value1, value2, "minNum");
            return (Criteria) this;
        }

        public Criteria andMinNumTypeIsNull() {
            addCriterion("min_num_type is null");
            return (Criteria) this;
        }

        public Criteria andMinNumTypeIsNotNull() {
            addCriterion("min_num_type is not null");
            return (Criteria) this;
        }

        public Criteria andMinNumTypeEqualTo(Short value) {
            addCriterion("min_num_type =", value, "minNumType");
            return (Criteria) this;
        }

        public Criteria andMinNumTypeNotEqualTo(Short value) {
            addCriterion("min_num_type <>", value, "minNumType");
            return (Criteria) this;
        }

        public Criteria andMinNumTypeGreaterThan(Short value) {
            addCriterion("min_num_type >", value, "minNumType");
            return (Criteria) this;
        }

        public Criteria andMinNumTypeGreaterThanOrEqualTo(Short value) {
            addCriterion("min_num_type >=", value, "minNumType");
            return (Criteria) this;
        }

        public Criteria andMinNumTypeLessThan(Short value) {
            addCriterion("min_num_type <", value, "minNumType");
            return (Criteria) this;
        }

        public Criteria andMinNumTypeLessThanOrEqualTo(Short value) {
            addCriterion("min_num_type <=", value, "minNumType");
            return (Criteria) this;
        }

        public Criteria andMinNumTypeIn(List<Short> values) {
            addCriterion("min_num_type in", values, "minNumType");
            return (Criteria) this;
        }

        public Criteria andMinNumTypeNotIn(List<Short> values) {
            addCriterion("min_num_type not in", values, "minNumType");
            return (Criteria) this;
        }

        public Criteria andMinNumTypeBetween(Short value1, Short value2) {
            addCriterion("min_num_type between", value1, value2, "minNumType");
            return (Criteria) this;
        }

        public Criteria andMinNumTypeNotBetween(Short value1, Short value2) {
            addCriterion("min_num_type not between", value1, value2, "minNumType");
            return (Criteria) this;
        }

        public Criteria andChildNumIsNull() {
            addCriterion("child_num is null");
            return (Criteria) this;
        }

        public Criteria andChildNumIsNotNull() {
            addCriterion("child_num is not null");
            return (Criteria) this;
        }

        public Criteria andChildNumEqualTo(BigDecimal value) {
            addCriterion("child_num =", value, "childNum");
            return (Criteria) this;
        }

        public Criteria andChildNumNotEqualTo(BigDecimal value) {
            addCriterion("child_num <>", value, "childNum");
            return (Criteria) this;
        }

        public Criteria andChildNumGreaterThan(BigDecimal value) {
            addCriterion("child_num >", value, "childNum");
            return (Criteria) this;
        }

        public Criteria andChildNumGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("child_num >=", value, "childNum");
            return (Criteria) this;
        }

        public Criteria andChildNumLessThan(BigDecimal value) {
            addCriterion("child_num <", value, "childNum");
            return (Criteria) this;
        }

        public Criteria andChildNumLessThanOrEqualTo(BigDecimal value) {
            addCriterion("child_num <=", value, "childNum");
            return (Criteria) this;
        }

        public Criteria andChildNumIn(List<BigDecimal> values) {
            addCriterion("child_num in", values, "childNum");
            return (Criteria) this;
        }

        public Criteria andChildNumNotIn(List<BigDecimal> values) {
            addCriterion("child_num not in", values, "childNum");
            return (Criteria) this;
        }

        public Criteria andChildNumBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("child_num between", value1, value2, "childNum");
            return (Criteria) this;
        }

        public Criteria andChildNumNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("child_num not between", value1, value2, "childNum");
            return (Criteria) this;
        }

        public Criteria andChildNumTypeIsNull() {
            addCriterion("child_num_type is null");
            return (Criteria) this;
        }

        public Criteria andChildNumTypeIsNotNull() {
            addCriterion("child_num_type is not null");
            return (Criteria) this;
        }

        public Criteria andChildNumTypeEqualTo(Short value) {
            addCriterion("child_num_type =", value, "childNumType");
            return (Criteria) this;
        }

        public Criteria andChildNumTypeNotEqualTo(Short value) {
            addCriterion("child_num_type <>", value, "childNumType");
            return (Criteria) this;
        }

        public Criteria andChildNumTypeGreaterThan(Short value) {
            addCriterion("child_num_type >", value, "childNumType");
            return (Criteria) this;
        }

        public Criteria andChildNumTypeGreaterThanOrEqualTo(Short value) {
            addCriterion("child_num_type >=", value, "childNumType");
            return (Criteria) this;
        }

        public Criteria andChildNumTypeLessThan(Short value) {
            addCriterion("child_num_type <", value, "childNumType");
            return (Criteria) this;
        }

        public Criteria andChildNumTypeLessThanOrEqualTo(Short value) {
            addCriterion("child_num_type <=", value, "childNumType");
            return (Criteria) this;
        }

        public Criteria andChildNumTypeIn(List<Short> values) {
            addCriterion("child_num_type in", values, "childNumType");
            return (Criteria) this;
        }

        public Criteria andChildNumTypeNotIn(List<Short> values) {
            addCriterion("child_num_type not in", values, "childNumType");
            return (Criteria) this;
        }

        public Criteria andChildNumTypeBetween(Short value1, Short value2) {
            addCriterion("child_num_type between", value1, value2, "childNumType");
            return (Criteria) this;
        }

        public Criteria andChildNumTypeNotBetween(Short value1, Short value2) {
            addCriterion("child_num_type not between", value1, value2, "childNumType");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("remark is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("remark is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("remark =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("remark <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("remark >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("remark >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("remark <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("remark <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("remark like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("remark not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("remark in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("remark not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("remark between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("remark not between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andReversionIsNull() {
            addCriterion("reversion is null");
            return (Criteria) this;
        }

        public Criteria andReversionIsNotNull() {
            addCriterion("reversion is not null");
            return (Criteria) this;
        }

        public Criteria andReversionEqualTo(Short value) {
            addCriterion("reversion =", value, "reversion");
            return (Criteria) this;
        }

        public Criteria andReversionNotEqualTo(Short value) {
            addCriterion("reversion <>", value, "reversion");
            return (Criteria) this;
        }

        public Criteria andReversionGreaterThan(Short value) {
            addCriterion("reversion >", value, "reversion");
            return (Criteria) this;
        }

        public Criteria andReversionGreaterThanOrEqualTo(Short value) {
            addCriterion("reversion >=", value, "reversion");
            return (Criteria) this;
        }

        public Criteria andReversionLessThan(Short value) {
            addCriterion("reversion <", value, "reversion");
            return (Criteria) this;
        }

        public Criteria andReversionLessThanOrEqualTo(Short value) {
            addCriterion("reversion <=", value, "reversion");
            return (Criteria) this;
        }

        public Criteria andReversionIn(List<Short> values) {
            addCriterion("reversion in", values, "reversion");
            return (Criteria) this;
        }

        public Criteria andReversionNotIn(List<Short> values) {
            addCriterion("reversion not in", values, "reversion");
            return (Criteria) this;
        }

        public Criteria andReversionBetween(Short value1, Short value2) {
            addCriterion("reversion between", value1, value2, "reversion");
            return (Criteria) this;
        }

        public Criteria andReversionNotBetween(Short value1, Short value2) {
            addCriterion("reversion not between", value1, value2, "reversion");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("create_time is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("create_time is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("create_time =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("create_time <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("create_time >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("create_time >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("create_time <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("create_time <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("create_time in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("create_time not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("create_time between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("create_time not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateByIsNull() {
            addCriterion("create_by is null");
            return (Criteria) this;
        }

        public Criteria andCreateByIsNotNull() {
            addCriterion("create_by is not null");
            return (Criteria) this;
        }

        public Criteria andCreateByEqualTo(Integer value) {
            addCriterion("create_by =", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByNotEqualTo(Integer value) {
            addCriterion("create_by <>", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByGreaterThan(Integer value) {
            addCriterion("create_by >", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByGreaterThanOrEqualTo(Integer value) {
            addCriterion("create_by >=", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByLessThan(Integer value) {
            addCriterion("create_by <", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByLessThanOrEqualTo(Integer value) {
            addCriterion("create_by <=", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByIn(List<Integer> values) {
            addCriterion("create_by in", values, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByNotIn(List<Integer> values) {
            addCriterion("create_by not in", values, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByBetween(Integer value1, Integer value2) {
            addCriterion("create_by between", value1, value2, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByNotBetween(Integer value1, Integer value2) {
            addCriterion("create_by not between", value1, value2, "createBy");
            return (Criteria) this;
        }

        public Criteria andUpdatedTimeIsNull() {
            addCriterion("updated_time is null");
            return (Criteria) this;
        }

        public Criteria andUpdatedTimeIsNotNull() {
            addCriterion("updated_time is not null");
            return (Criteria) this;
        }

        public Criteria andUpdatedTimeEqualTo(Date value) {
            addCriterion("updated_time =", value, "updatedTime");
            return (Criteria) this;
        }

        public Criteria andUpdatedTimeNotEqualTo(Date value) {
            addCriterion("updated_time <>", value, "updatedTime");
            return (Criteria) this;
        }

        public Criteria andUpdatedTimeGreaterThan(Date value) {
            addCriterion("updated_time >", value, "updatedTime");
            return (Criteria) this;
        }

        public Criteria andUpdatedTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("updated_time >=", value, "updatedTime");
            return (Criteria) this;
        }

        public Criteria andUpdatedTimeLessThan(Date value) {
            addCriterion("updated_time <", value, "updatedTime");
            return (Criteria) this;
        }

        public Criteria andUpdatedTimeLessThanOrEqualTo(Date value) {
            addCriterion("updated_time <=", value, "updatedTime");
            return (Criteria) this;
        }

        public Criteria andUpdatedTimeIn(List<Date> values) {
            addCriterion("updated_time in", values, "updatedTime");
            return (Criteria) this;
        }

        public Criteria andUpdatedTimeNotIn(List<Date> values) {
            addCriterion("updated_time not in", values, "updatedTime");
            return (Criteria) this;
        }

        public Criteria andUpdatedTimeBetween(Date value1, Date value2) {
            addCriterion("updated_time between", value1, value2, "updatedTime");
            return (Criteria) this;
        }

        public Criteria andUpdatedTimeNotBetween(Date value1, Date value2) {
            addCriterion("updated_time not between", value1, value2, "updatedTime");
            return (Criteria) this;
        }

        public Criteria andUpdatedByIsNull() {
            addCriterion("updated_by is null");
            return (Criteria) this;
        }

        public Criteria andUpdatedByIsNotNull() {
            addCriterion("updated_by is not null");
            return (Criteria) this;
        }

        public Criteria andUpdatedByEqualTo(Integer value) {
            addCriterion("updated_by =", value, "updatedBy");
            return (Criteria) this;
        }

        public Criteria andUpdatedByNotEqualTo(Integer value) {
            addCriterion("updated_by <>", value, "updatedBy");
            return (Criteria) this;
        }

        public Criteria andUpdatedByGreaterThan(Integer value) {
            addCriterion("updated_by >", value, "updatedBy");
            return (Criteria) this;
        }

        public Criteria andUpdatedByGreaterThanOrEqualTo(Integer value) {
            addCriterion("updated_by >=", value, "updatedBy");
            return (Criteria) this;
        }

        public Criteria andUpdatedByLessThan(Integer value) {
            addCriterion("updated_by <", value, "updatedBy");
            return (Criteria) this;
        }

        public Criteria andUpdatedByLessThanOrEqualTo(Integer value) {
            addCriterion("updated_by <=", value, "updatedBy");
            return (Criteria) this;
        }

        public Criteria andUpdatedByIn(List<Integer> values) {
            addCriterion("updated_by in", values, "updatedBy");
            return (Criteria) this;
        }

        public Criteria andUpdatedByNotIn(List<Integer> values) {
            addCriterion("updated_by not in", values, "updatedBy");
            return (Criteria) this;
        }

        public Criteria andUpdatedByBetween(Integer value1, Integer value2) {
            addCriterion("updated_by between", value1, value2, "updatedBy");
            return (Criteria) this;
        }

        public Criteria andUpdatedByNotBetween(Integer value1, Integer value2) {
            addCriterion("updated_by not between", value1, value2, "updatedBy");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNull() {
            addCriterion("deleted is null");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNotNull() {
            addCriterion("deleted is not null");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualTo(Short value) {
            addCriterion("deleted =", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualTo(Short value) {
            addCriterion("deleted <>", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThan(Short value) {
            addCriterion("deleted >", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualTo(Short value) {
            addCriterion("deleted >=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThan(Short value) {
            addCriterion("deleted <", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualTo(Short value) {
            addCriterion("deleted <=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedIn(List<Short> values) {
            addCriterion("deleted in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotIn(List<Short> values) {
            addCriterion("deleted not in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedBetween(Short value1, Short value2) {
            addCriterion("deleted between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotBetween(Short value1, Short value2) {
            addCriterion("deleted not between", value1, value2, "deleted");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}